/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *, '2022-10-14' as dt from customer_relationship where 1=1 and (create_date_time between '2010-01-01 00:00:00' and '2022-10-14 23:59:59') or (update_date_time between '2010-01-01 00:00:00' and '2022-10-14 23:59:59') and  \$CONDITIONS" \
--hcatalog-database zx_ods \
--hcatalog-table customer_relationship \
-m 1

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *, '2022-10-14' as dt from customer_appeal where 1=1 and  \$CONDITIONS" \
--hcatalog-database yp_ods \
--hcatalog-table customer_appeal \
-m 1

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *, '2022-10-14' as dt from employee where 1=1 and  \$CONDITIONS" \
--hcatalog-database yp_ods \
--hcatalog-table employee \
-m 1

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *, '2022-10-14' as dt from scrm_department where 1=1 and  \$CONDITIONS" \
--hcatalog-database yp_ods \
--hcatalog-table scrm_department \
-m 1